How to write nested subquery in SQL

join shbcf.ru